Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_99

R_99

OrgUnitFunctionMH

ExternalOrgUnit

OrgUnitFunctionMHID

 

 

R_134

R_134

Address

LOrgUnitAddress

AddressID

 

 

R_178

R_178

Address

LExternalOrgUnitAddress

AddressID

 

 

R_181

R_181

ExternalOrgUnit

LExternalOrgUnitAddress

ExternalOrgUnitID

 

 

R_186

R_186

Service

LOrgUnitServ

ServID

 

 

R_201

R_201

EpisodeType

LEpisodeTypeOrgUnit

EpisodeTypeID

 

 

R_222

R_222

OrgUnitType

OrgUnitTypeText

OrgUnitTypeID

 

 

R_334

R_334

HospitalMainBook

Hospital

HospitalMainBookNoID

 

 

R_345

R_345

Hospital

LHospitalOrgUnit

HospitalID

 

 

R_347

R_347

OrgUnitFunction

LOrgUnitFunction

OrgUnitFunctionID

 

 

R_348

R_348

OrgUnitFunction

OrgUnitFunctionText

OrgUnitFunctionID

 

 

R_370

R_370

OrgUnitFunctionMH

OrgUnitFunctionMHText

OrgUnitFunctionMHID

 

 

R_407

R_407

HierarchyType

HierarchyTypeText

HierarchyTypeID

 

 

R_415

R_415

BedsType

BedsTypeText

BedsTypeID

 

 

R_416

R_416

BedsType

Beds

BedsTypeID

 

 

R_625

R_625

OrgUnitKind

OrgUnitKindText

OrgUnitKindID

 

 

R_707

R_707

ExternalOrgUnitType

ExternalOrgUnit

ExternalOrgUnitTypeID

 

 

R_709

R_709

ExternalOrgUnitType

ExternalOrgUnitTypeText

ExternalOrgUnitTypeID

 

 

R_731

R_731

OrgUnitGroup

LOrgUnitGroup

OrgUnitGroupID

 

 

R_1322

R_1322

Personnel

LOrgUnitPersonnel

PersonID

 

 

R_1323

R_1323

PersonnelFunctionMetaType

PersonnelFunction

PersonnelFunctionMetaTypeID

 

 

R_1324

R_1324

PersonnelFunctionMetaType

PersonnelFunctionMetaTypeText

PersonnelFunctionMetaTypeID

 

 

R_1326

R_1326

PersonnelFunction

LOrgUnitPersonnel

PersonnelFunctionID

 

 

R_1430

R_1430

ContactType

ContactTypeText

ContactTypeID

 

 

R_1433

R_1433

ContactType

Contact

ContactTypeID

 

 

R_1640

R_1640

PersonnelTypeMH

PersonnelTypeMHText

PersonnelTypeMHID

 

 

R_1641

R_1641

PersonnelTypeMH

Personnel

PersonnelTypeMHID

 

 

R_4060

R_4060

FounderBody

FounderBodyText

FounderBodyID

 

 

R_9188

R_9188

Recorder

RecorderText

RecorderID

 

 

R_9190

R_9190

Recorder

LOrgUnitRecorder

RecorderID

 

 

R_9192

R_9192

DiscFormatText

LOrgUnitDiscFormat

DiscFormatTextCode

 

 

R_9193

R_9193

DiscFormat

DiscFormatText

DiscFormatID

 

 

R_9581

R_9581

BedsType

LBedsTypeBedsAttribute

BedsTypeID

 

 

R_9582

R_9582

BedsAttribute

LBedsTypeBedsAttribute

BedsAttributeID

 

 

R_9583

R_9583

BedsAttribute

BedsAttributeText

BedsAttributeID

 

 

R_9791

R_9791

DictionaryValue

ExternalOrgUnit

ContractorTypeID